| SaTitleFourTableWork |
| Logical Entity Name | SaTitleFourTableWork |
| Default Table Name | SaTitleFourTableWork |
| Physical Only | NO |
| Definition | |
| Note |
| SaTitleFourTableWork Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| StudentName | varchar(75) | YES | ||
| CampusCode | varchar(30) | YES | ||
| CampusDescrip | varchar(50) | YES | ||
| FundSourceCode | varchar(20) | YES | ||
| syCampusID | int | YES | ||
| SyStudentID | int | YES | ||
| AdEnrollID | int | YES | ||
| FaStudentAYID | int | YES | ||
| FaStudentAidID | int | YES | ||
| FaFundSourceID | int | YES | ||
| AwardYear | char(8) | YES | ||
| Stipend | money | YES | ||
| stunum | varchar(12) | YES | ||
| UserId | int | YES | ||
| BatchID | int | YES | ||
| IsProceed | bit | YES | ||
| FaStudentAyStartDate1 | datetime | YES | ||
| FaStudentAyStartDate2 | datetime | YES | ||
| FaStudentAyEndDate1 | datetime | YES | ||
| FaStudentAyEndDate2 | datetime | YES | ||
| AwardYearFilter | varchar(8) | YES | ||
| StaffName | varchar(80) | YES | ||
SaTitleFourTableWorkID |
int | NO | ||
| FundSourceDescrip | varchar(60) | YES |
| SaTitleFourTableWork Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_SaTitleFourTableWork_SaTitleFourTableWorkID | PrimaryKey | SaTitleFourTableWorkID |
| SaTitleFourTableWork Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaTitleFourTableWork Check Constraints |
| Check Constraint Name | CheckConstraint |